﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Creating an Oracle Database</title>
<meta name="GENERATOR" content="WinCHM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

</head>

<body>
<P><A 
href="http://khanh.com.vn/post/2011/08/21/Tao-database-tren-Oracle-11g-R2-su-dung-DBCA.aspx">http://khanh.com.vn/post/2011/08/21/Tao-database-tren-Oracle-11g-R2-su-dung-DBCA.aspx</A></P>
<P><A href="https://<IP-Server >:1158/em" ><FONT 
face=Courier>https://&lt;IP-Server&gt;:1158/em</FONT></A></P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"></SPAN>&nbsp;</P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">Schema 
chỉ là 1 phần trong Database thôi.</SPAN><BR>Muốn 
truy xuất vào một đối tượng trong SQL Server thì phải đủ 4 thành phần</SPAN><BR 
style="WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px; webkit-box-shadow: none; box-shadow: none; border-top-left-radius: 0px; border-top-right-radius: 0px; border-bottom-right-radius: 0px; border-bottom-left-radius: 0px"><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><FONT 
face=Courier><STRONG>[linked-server].[DBName].[SchemaName].[Objectname]</STRONG></FONT></SPAN></P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"></SPAN><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">Mục đích của Schema cũng là để dễ dàng quản lý các nhóm đối 
tượng, phân quyền, v.v... Trên SQL Server 2000 có thể coi Schema và User gần như 
nhau song từ 2k5 trở về sau là hoàn toàn tách biệt</SPAN></P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">Bình thường Schema trong SQL Server là dbo.<BR>Do đó bạn 
thường hay thấy trước tên bảng có dbo.</SPAN></P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">ĐẦU TIÊN BAO 
GIỜ CŨNG LÀ TẠO TABLE BẰNG CÂU LỆNH</SPAN></P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><BR>&nbsp;</P></SPAN>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">   
       </SPAN>&nbsp;</P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">   
       </SPAN>&nbsp;</P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"></SPAN><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">
<TABLE style="BORDER-COLLAPSE: collapse" borderColor=#000000 cellSpacing=0 
cellPadding=2 width="100%" border=1>
  
  <TR>
    <TD><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 13px/15px Tahoma, Geneva, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><FONT ><FONT >sql auto 
increment</FONT> </FONT>  </SPAN></TD>
    <TD><A 
      href="http://earlruby.org/2009/01/creating-auto-increment-columns-in-oracle/"><FONT 
      >http://earlruby.org/2009/01/creating-auto-increment-columns-in-oracle/</FONT></A></TD></TR>
  <TR>
    <TD><FONT ><SPAN 
      class=x59>Primary Key</SPAN></FONT></TD>
    <TD><FONT 
></FONT></TD></TR>
  <TR>
    <TD><SPAN class=x59>Unique Key</SPAN></TD>
    <TD></TD></TR>
  <TR>
    <TD><SPAN class=x59>SecureFile LOB</SPAN></TD>
    <TD></TD></TR></TABLE></SPAN></P>
<P><FONT ><A 
href="http://www.techonthenet.com/oracle/primary_keys.php">http://www.techonthenet.com/oracle/primary_keys.php</A></FONT></P>
<P>câu lệnh để tạo table có primary key</P>
<P>       &nbsp;</P>
<P>nếu insert đến mức id =    
    2147483647&nbsp;thì ko thể insert thêm được</P>
<H1 
style="FONT-SIZE: 18px; MARGIN: 0.5em 0px 0.1em; WORD-SPACING: 0px; TEXT-TRANSFORM: none; COLOR: rgb(51,51,51); TEXT-INDENT: 0px; LINE-HEIGHT: normal; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(238,238,238); TEXT-ALIGN: left; FONT-VARIANT: normal; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">Reset 
the auto increment value for a MySQL table<BR><A 
href="http://www.electrictoolbox.com/reset-auto-increment-value-mysql/">http://www.electrictoolbox.com/reset-auto-increment-value-mysql/</A></H1>
<P>       TNS NAME       ORACLE</P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 14px/18px Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(238,238,238); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px">tnsping</SPAN>       </P>
<H1 
style="BORDER-RIGHT: 0px; PADDING-RIGHT: 0px; BORDER-TOP: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px 0px 7px; WORD-SPACING: 0px; FONT: bold 23px/1.3 'Trebuchet MS', 'Liberation Sans', 'DejaVu Sans', sans-serif; VERTICAL-ALIGN: baseline; TEXT-TRANSFORM: none; BORDER-LEFT: 0px; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; PADDING-TOP: 0px; BORDER-BOTTOM: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px" 
itemprop="name"><A class=question-hyperlink 
style="BORDER-RIGHT: 0px; PADDING-RIGHT: 0px; BORDER-TOP: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: bold; FONT-SIZE: 23px; PADDING-BOTTOM: 0px; MARGIN: 0px; VERTICAL-ALIGN: baseline; BORDER-LEFT: 0px; CURSOR: pointer; COLOR: rgb(0,0,0); PADDING-TOP: 0px; BORDER-BOTTOM: 0px; BACKGROUND-COLOR: transparent; TEXT-DECORATION: underline" 
href="http://stackoverflow.com/questions/2019230/use-tnsnames-ora-in-oracle-sql-developer">Use 
tnsnames.ora in Oracle SQL Developer</A></H1>
<P><A 
href="http://stackoverflow.com/questions/425029/oracle-tns-names-not-showing-when-adding-new-connection-to-sql-developer/425104#425104">http://stackoverflow.com/questions/425029/oracle-tns-names-not-showing-when-adding-new-connection-to-sql-developer/425104#425104</A>         </P>
<P> echo %TEN_BIEN_MOI_TRUONG_TRONG_WIN%       </P>
<P> D:\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora       </P>
<P>       </P>
<P>       </P>
<P><SPAN 
style="DISPLAY: inline! important; FLOAT: none; WORD-SPACING: 0px; FONT: 14px/18px Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(238,238,238); TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><A 
href="http://www.rgagnon.com/javadetails/java-0112.html"><FONT 
face="Courier" color  =#ff0000 
size=3>http://www.rgagnon.com/javadetails/java-0112.html</FONT></A></SPAN><FONT 
face=Courier>&nbsp; - demo 2 cách java connect Oracle, một thông thường, và 1 dùng tnsnames.ora, </FONT> 
             </P></body>
</html>
